package com.runfast.waimai.dao.model;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class RunfastActivityExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public RunfastActivityExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Integer value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Integer value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Integer value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Integer value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Integer value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Integer> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Integer> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Integer value1, Integer value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Integer value1, Integer value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andBusidIsNull() {
            addCriterion("busId is null");
            return (Criteria) this;
        }

        public Criteria andBusidIsNotNull() {
            addCriterion("busId is not null");
            return (Criteria) this;
        }

        public Criteria andBusidEqualTo(Integer value) {
            addCriterion("busId =", value, "busid");
            return (Criteria) this;
        }

        public Criteria andBusidNotEqualTo(Integer value) {
            addCriterion("busId <>", value, "busid");
            return (Criteria) this;
        }

        public Criteria andBusidGreaterThan(Integer value) {
            addCriterion("busId >", value, "busid");
            return (Criteria) this;
        }

        public Criteria andBusidGreaterThanOrEqualTo(Integer value) {
            addCriterion("busId >=", value, "busid");
            return (Criteria) this;
        }

        public Criteria andBusidLessThan(Integer value) {
            addCriterion("busId <", value, "busid");
            return (Criteria) this;
        }

        public Criteria andBusidLessThanOrEqualTo(Integer value) {
            addCriterion("busId <=", value, "busid");
            return (Criteria) this;
        }

        public Criteria andBusidIn(List<Integer> values) {
            addCriterion("busId in", values, "busid");
            return (Criteria) this;
        }

        public Criteria andBusidNotIn(List<Integer> values) {
            addCriterion("busId not in", values, "busid");
            return (Criteria) this;
        }

        public Criteria andBusidBetween(Integer value1, Integer value2) {
            addCriterion("busId between", value1, value2, "busid");
            return (Criteria) this;
        }

        public Criteria andBusidNotBetween(Integer value1, Integer value2) {
            addCriterion("busId not between", value1, value2, "busid");
            return (Criteria) this;
        }

        public Criteria andBusnameIsNull() {
            addCriterion("busname is null");
            return (Criteria) this;
        }

        public Criteria andBusnameIsNotNull() {
            addCriterion("busname is not null");
            return (Criteria) this;
        }

        public Criteria andBusnameEqualTo(String value) {
            addCriterion("busname =", value, "busname");
            return (Criteria) this;
        }

        public Criteria andBusnameNotEqualTo(String value) {
            addCriterion("busname <>", value, "busname");
            return (Criteria) this;
        }

        public Criteria andBusnameGreaterThan(String value) {
            addCriterion("busname >", value, "busname");
            return (Criteria) this;
        }

        public Criteria andBusnameGreaterThanOrEqualTo(String value) {
            addCriterion("busname >=", value, "busname");
            return (Criteria) this;
        }

        public Criteria andBusnameLessThan(String value) {
            addCriterion("busname <", value, "busname");
            return (Criteria) this;
        }

        public Criteria andBusnameLessThanOrEqualTo(String value) {
            addCriterion("busname <=", value, "busname");
            return (Criteria) this;
        }

        public Criteria andBusnameLike(String value) {
            addCriterion("busname like", value, "busname");
            return (Criteria) this;
        }

        public Criteria andBusnameNotLike(String value) {
            addCriterion("busname not like", value, "busname");
            return (Criteria) this;
        }

        public Criteria andBusnameIn(List<String> values) {
            addCriterion("busname in", values, "busname");
            return (Criteria) this;
        }

        public Criteria andBusnameNotIn(List<String> values) {
            addCriterion("busname not in", values, "busname");
            return (Criteria) this;
        }

        public Criteria andBusnameBetween(String value1, String value2) {
            addCriterion("busname between", value1, value2, "busname");
            return (Criteria) this;
        }

        public Criteria andBusnameNotBetween(String value1, String value2) {
            addCriterion("busname not between", value1, value2, "busname");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIsNull() {
            addCriterion("createTime is null");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIsNotNull() {
            addCriterion("createTime is not null");
            return (Criteria) this;
        }

        public Criteria andCreatetimeEqualTo(Date value) {
            addCriterion("createTime =", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotEqualTo(Date value) {
            addCriterion("createTime <>", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeGreaterThan(Date value) {
            addCriterion("createTime >", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeGreaterThanOrEqualTo(Date value) {
            addCriterion("createTime >=", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeLessThan(Date value) {
            addCriterion("createTime <", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeLessThanOrEqualTo(Date value) {
            addCriterion("createTime <=", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIn(List<Date> values) {
            addCriterion("createTime in", values, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotIn(List<Date> values) {
            addCriterion("createTime not in", values, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeBetween(Date value1, Date value2) {
            addCriterion("createTime between", value1, value2, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotBetween(Date value1, Date value2) {
            addCriterion("createTime not between", value1, value2, "createtime");
            return (Criteria) this;
        }

        public Criteria andDiscountIsNull() {
            addCriterion("discount is null");
            return (Criteria) this;
        }

        public Criteria andDiscountIsNotNull() {
            addCriterion("discount is not null");
            return (Criteria) this;
        }

        public Criteria andDiscountEqualTo(Double value) {
            addCriterion("discount =", value, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountNotEqualTo(Double value) {
            addCriterion("discount <>", value, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountGreaterThan(Double value) {
            addCriterion("discount >", value, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountGreaterThanOrEqualTo(Double value) {
            addCriterion("discount >=", value, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountLessThan(Double value) {
            addCriterion("discount <", value, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountLessThanOrEqualTo(Double value) {
            addCriterion("discount <=", value, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountIn(List<Double> values) {
            addCriterion("discount in", values, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountNotIn(List<Double> values) {
            addCriterion("discount not in", values, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountBetween(Double value1, Double value2) {
            addCriterion("discount between", value1, value2, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountNotBetween(Double value1, Double value2) {
            addCriterion("discount not between", value1, value2, "discount");
            return (Criteria) this;
        }

        public Criteria andEndtimeIsNull() {
            addCriterion("endTime is null");
            return (Criteria) this;
        }

        public Criteria andEndtimeIsNotNull() {
            addCriterion("endTime is not null");
            return (Criteria) this;
        }

        public Criteria andEndtimeEqualTo(Date value) {
            addCriterion("endTime =", value, "endtime");
            return (Criteria) this;
        }

        public Criteria andEndtimeNotEqualTo(Date value) {
            addCriterion("endTime <>", value, "endtime");
            return (Criteria) this;
        }

        public Criteria andEndtimeGreaterThan(Date value) {
            addCriterion("endTime >", value, "endtime");
            return (Criteria) this;
        }

        public Criteria andEndtimeGreaterThanOrEqualTo(Date value) {
            addCriterion("endTime >=", value, "endtime");
            return (Criteria) this;
        }

        public Criteria andEndtimeLessThan(Date value) {
            addCriterion("endTime <", value, "endtime");
            return (Criteria) this;
        }

        public Criteria andEndtimeLessThanOrEqualTo(Date value) {
            addCriterion("endTime <=", value, "endtime");
            return (Criteria) this;
        }

        public Criteria andEndtimeIn(List<Date> values) {
            addCriterion("endTime in", values, "endtime");
            return (Criteria) this;
        }

        public Criteria andEndtimeNotIn(List<Date> values) {
            addCriterion("endTime not in", values, "endtime");
            return (Criteria) this;
        }

        public Criteria andEndtimeBetween(Date value1, Date value2) {
            addCriterion("endTime between", value1, value2, "endtime");
            return (Criteria) this;
        }

        public Criteria andEndtimeNotBetween(Date value1, Date value2) {
            addCriterion("endTime not between", value1, value2, "endtime");
            return (Criteria) this;
        }

        public Criteria andFullsIsNull() {
            addCriterion("fulls is null");
            return (Criteria) this;
        }

        public Criteria andFullsIsNotNull() {
            addCriterion("fulls is not null");
            return (Criteria) this;
        }

        public Criteria andFullsEqualTo(Double value) {
            addCriterion("fulls =", value, "fulls");
            return (Criteria) this;
        }

        public Criteria andFullsNotEqualTo(Double value) {
            addCriterion("fulls <>", value, "fulls");
            return (Criteria) this;
        }

        public Criteria andFullsGreaterThan(Double value) {
            addCriterion("fulls >", value, "fulls");
            return (Criteria) this;
        }

        public Criteria andFullsGreaterThanOrEqualTo(Double value) {
            addCriterion("fulls >=", value, "fulls");
            return (Criteria) this;
        }

        public Criteria andFullsLessThan(Double value) {
            addCriterion("fulls <", value, "fulls");
            return (Criteria) this;
        }

        public Criteria andFullsLessThanOrEqualTo(Double value) {
            addCriterion("fulls <=", value, "fulls");
            return (Criteria) this;
        }

        public Criteria andFullsIn(List<Double> values) {
            addCriterion("fulls in", values, "fulls");
            return (Criteria) this;
        }

        public Criteria andFullsNotIn(List<Double> values) {
            addCriterion("fulls not in", values, "fulls");
            return (Criteria) this;
        }

        public Criteria andFullsBetween(Double value1, Double value2) {
            addCriterion("fulls between", value1, value2, "fulls");
            return (Criteria) this;
        }

        public Criteria andFullsNotBetween(Double value1, Double value2) {
            addCriterion("fulls not between", value1, value2, "fulls");
            return (Criteria) this;
        }

        public Criteria andLesssIsNull() {
            addCriterion("lesss is null");
            return (Criteria) this;
        }

        public Criteria andLesssIsNotNull() {
            addCriterion("lesss is not null");
            return (Criteria) this;
        }

        public Criteria andLesssEqualTo(Double value) {
            addCriterion("lesss =", value, "lesss");
            return (Criteria) this;
        }

        public Criteria andLesssNotEqualTo(Double value) {
            addCriterion("lesss <>", value, "lesss");
            return (Criteria) this;
        }

        public Criteria andLesssGreaterThan(Double value) {
            addCriterion("lesss >", value, "lesss");
            return (Criteria) this;
        }

        public Criteria andLesssGreaterThanOrEqualTo(Double value) {
            addCriterion("lesss >=", value, "lesss");
            return (Criteria) this;
        }

        public Criteria andLesssLessThan(Double value) {
            addCriterion("lesss <", value, "lesss");
            return (Criteria) this;
        }

        public Criteria andLesssLessThanOrEqualTo(Double value) {
            addCriterion("lesss <=", value, "lesss");
            return (Criteria) this;
        }

        public Criteria andLesssIn(List<Double> values) {
            addCriterion("lesss in", values, "lesss");
            return (Criteria) this;
        }

        public Criteria andLesssNotIn(List<Double> values) {
            addCriterion("lesss not in", values, "lesss");
            return (Criteria) this;
        }

        public Criteria andLesssBetween(Double value1, Double value2) {
            addCriterion("lesss between", value1, value2, "lesss");
            return (Criteria) this;
        }

        public Criteria andLesssNotBetween(Double value1, Double value2) {
            addCriterion("lesss not between", value1, value2, "lesss");
            return (Criteria) this;
        }

        public Criteria andNameIsNull() {
            addCriterion("name is null");
            return (Criteria) this;
        }

        public Criteria andNameIsNotNull() {
            addCriterion("name is not null");
            return (Criteria) this;
        }

        public Criteria andNameEqualTo(String value) {
            addCriterion("name =", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotEqualTo(String value) {
            addCriterion("name <>", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameGreaterThan(String value) {
            addCriterion("name >", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameGreaterThanOrEqualTo(String value) {
            addCriterion("name >=", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLessThan(String value) {
            addCriterion("name <", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLessThanOrEqualTo(String value) {
            addCriterion("name <=", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLike(String value) {
            addCriterion("name like", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotLike(String value) {
            addCriterion("name not like", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameIn(List<String> values) {
            addCriterion("name in", values, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotIn(List<String> values) {
            addCriterion("name not in", values, "name");
            return (Criteria) this;
        }

        public Criteria andNameBetween(String value1, String value2) {
            addCriterion("name between", value1, value2, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotBetween(String value1, String value2) {
            addCriterion("name not between", value1, value2, "name");
            return (Criteria) this;
        }

        public Criteria andPtypeIsNull() {
            addCriterion("ptype is null");
            return (Criteria) this;
        }

        public Criteria andPtypeIsNotNull() {
            addCriterion("ptype is not null");
            return (Criteria) this;
        }

        public Criteria andPtypeEqualTo(Integer value) {
            addCriterion("ptype =", value, "ptype");
            return (Criteria) this;
        }

        public Criteria andPtypeNotEqualTo(Integer value) {
            addCriterion("ptype <>", value, "ptype");
            return (Criteria) this;
        }

        public Criteria andPtypeGreaterThan(Integer value) {
            addCriterion("ptype >", value, "ptype");
            return (Criteria) this;
        }

        public Criteria andPtypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("ptype >=", value, "ptype");
            return (Criteria) this;
        }

        public Criteria andPtypeLessThan(Integer value) {
            addCriterion("ptype <", value, "ptype");
            return (Criteria) this;
        }

        public Criteria andPtypeLessThanOrEqualTo(Integer value) {
            addCriterion("ptype <=", value, "ptype");
            return (Criteria) this;
        }

        public Criteria andPtypeIn(List<Integer> values) {
            addCriterion("ptype in", values, "ptype");
            return (Criteria) this;
        }

        public Criteria andPtypeNotIn(List<Integer> values) {
            addCriterion("ptype not in", values, "ptype");
            return (Criteria) this;
        }

        public Criteria andPtypeBetween(Integer value1, Integer value2) {
            addCriterion("ptype between", value1, value2, "ptype");
            return (Criteria) this;
        }

        public Criteria andPtypeNotBetween(Integer value1, Integer value2) {
            addCriterion("ptype not between", value1, value2, "ptype");
            return (Criteria) this;
        }

        public Criteria andStarttimeIsNull() {
            addCriterion("startTime is null");
            return (Criteria) this;
        }

        public Criteria andStarttimeIsNotNull() {
            addCriterion("startTime is not null");
            return (Criteria) this;
        }

        public Criteria andStarttimeEqualTo(Date value) {
            addCriterion("startTime =", value, "starttime");
            return (Criteria) this;
        }

        public Criteria andStarttimeNotEqualTo(Date value) {
            addCriterion("startTime <>", value, "starttime");
            return (Criteria) this;
        }

        public Criteria andStarttimeGreaterThan(Date value) {
            addCriterion("startTime >", value, "starttime");
            return (Criteria) this;
        }

        public Criteria andStarttimeGreaterThanOrEqualTo(Date value) {
            addCriterion("startTime >=", value, "starttime");
            return (Criteria) this;
        }

        public Criteria andStarttimeLessThan(Date value) {
            addCriterion("startTime <", value, "starttime");
            return (Criteria) this;
        }

        public Criteria andStarttimeLessThanOrEqualTo(Date value) {
            addCriterion("startTime <=", value, "starttime");
            return (Criteria) this;
        }

        public Criteria andStarttimeIn(List<Date> values) {
            addCriterion("startTime in", values, "starttime");
            return (Criteria) this;
        }

        public Criteria andStarttimeNotIn(List<Date> values) {
            addCriterion("startTime not in", values, "starttime");
            return (Criteria) this;
        }

        public Criteria andStarttimeBetween(Date value1, Date value2) {
            addCriterion("startTime between", value1, value2, "starttime");
            return (Criteria) this;
        }

        public Criteria andStarttimeNotBetween(Date value1, Date value2) {
            addCriterion("startTime not between", value1, value2, "starttime");
            return (Criteria) this;
        }

        public Criteria andTypeIsNull() {
            addCriterion("type is null");
            return (Criteria) this;
        }

        public Criteria andTypeIsNotNull() {
            addCriterion("type is not null");
            return (Criteria) this;
        }

        public Criteria andTypeEqualTo(Integer value) {
            addCriterion("type =", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotEqualTo(Integer value) {
            addCriterion("type <>", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeGreaterThan(Integer value) {
            addCriterion("type >", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("type >=", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeLessThan(Integer value) {
            addCriterion("type <", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeLessThanOrEqualTo(Integer value) {
            addCriterion("type <=", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeIn(List<Integer> values) {
            addCriterion("type in", values, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotIn(List<Integer> values) {
            addCriterion("type not in", values, "type");
            return (Criteria) this;
        }

        public Criteria andTypeBetween(Integer value1, Integer value2) {
            addCriterion("type between", value1, value2, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("type not between", value1, value2, "type");
            return (Criteria) this;
        }

        public Criteria andGoodidsIsNull() {
            addCriterion("goodids is null");
            return (Criteria) this;
        }

        public Criteria andGoodidsIsNotNull() {
            addCriterion("goodids is not null");
            return (Criteria) this;
        }

        public Criteria andGoodidsEqualTo(String value) {
            addCriterion("goodids =", value, "goodids");
            return (Criteria) this;
        }

        public Criteria andGoodidsNotEqualTo(String value) {
            addCriterion("goodids <>", value, "goodids");
            return (Criteria) this;
        }

        public Criteria andGoodidsGreaterThan(String value) {
            addCriterion("goodids >", value, "goodids");
            return (Criteria) this;
        }

        public Criteria andGoodidsGreaterThanOrEqualTo(String value) {
            addCriterion("goodids >=", value, "goodids");
            return (Criteria) this;
        }

        public Criteria andGoodidsLessThan(String value) {
            addCriterion("goodids <", value, "goodids");
            return (Criteria) this;
        }

        public Criteria andGoodidsLessThanOrEqualTo(String value) {
            addCriterion("goodids <=", value, "goodids");
            return (Criteria) this;
        }

        public Criteria andGoodidsLike(String value) {
            addCriterion("goodids like", value, "goodids");
            return (Criteria) this;
        }

        public Criteria andGoodidsNotLike(String value) {
            addCriterion("goodids not like", value, "goodids");
            return (Criteria) this;
        }

        public Criteria andGoodidsIn(List<String> values) {
            addCriterion("goodids in", values, "goodids");
            return (Criteria) this;
        }

        public Criteria andGoodidsNotIn(List<String> values) {
            addCriterion("goodids not in", values, "goodids");
            return (Criteria) this;
        }

        public Criteria andGoodidsBetween(String value1, String value2) {
            addCriterion("goodids between", value1, value2, "goodids");
            return (Criteria) this;
        }

        public Criteria andGoodidsNotBetween(String value1, String value2) {
            addCriterion("goodids not between", value1, value2, "goodids");
            return (Criteria) this;
        }

        public Criteria andGoodsnameIsNull() {
            addCriterion("goodsname is null");
            return (Criteria) this;
        }

        public Criteria andGoodsnameIsNotNull() {
            addCriterion("goodsname is not null");
            return (Criteria) this;
        }

        public Criteria andGoodsnameEqualTo(String value) {
            addCriterion("goodsname =", value, "goodsname");
            return (Criteria) this;
        }

        public Criteria andGoodsnameNotEqualTo(String value) {
            addCriterion("goodsname <>", value, "goodsname");
            return (Criteria) this;
        }

        public Criteria andGoodsnameGreaterThan(String value) {
            addCriterion("goodsname >", value, "goodsname");
            return (Criteria) this;
        }

        public Criteria andGoodsnameGreaterThanOrEqualTo(String value) {
            addCriterion("goodsname >=", value, "goodsname");
            return (Criteria) this;
        }

        public Criteria andGoodsnameLessThan(String value) {
            addCriterion("goodsname <", value, "goodsname");
            return (Criteria) this;
        }

        public Criteria andGoodsnameLessThanOrEqualTo(String value) {
            addCriterion("goodsname <=", value, "goodsname");
            return (Criteria) this;
        }

        public Criteria andGoodsnameLike(String value) {
            addCriterion("goodsname like", value, "goodsname");
            return (Criteria) this;
        }

        public Criteria andGoodsnameNotLike(String value) {
            addCriterion("goodsname not like", value, "goodsname");
            return (Criteria) this;
        }

        public Criteria andGoodsnameIn(List<String> values) {
            addCriterion("goodsname in", values, "goodsname");
            return (Criteria) this;
        }

        public Criteria andGoodsnameNotIn(List<String> values) {
            addCriterion("goodsname not in", values, "goodsname");
            return (Criteria) this;
        }

        public Criteria andGoodsnameBetween(String value1, String value2) {
            addCriterion("goodsname between", value1, value2, "goodsname");
            return (Criteria) this;
        }

        public Criteria andGoodsnameNotBetween(String value1, String value2) {
            addCriterion("goodsname not between", value1, value2, "goodsname");
            return (Criteria) this;
        }

        public Criteria andAgentidIsNull() {
            addCriterion("agentId is null");
            return (Criteria) this;
        }

        public Criteria andAgentidIsNotNull() {
            addCriterion("agentId is not null");
            return (Criteria) this;
        }

        public Criteria andAgentidEqualTo(Integer value) {
            addCriterion("agentId =", value, "agentid");
            return (Criteria) this;
        }

        public Criteria andAgentidNotEqualTo(Integer value) {
            addCriterion("agentId <>", value, "agentid");
            return (Criteria) this;
        }

        public Criteria andAgentidGreaterThan(Integer value) {
            addCriterion("agentId >", value, "agentid");
            return (Criteria) this;
        }

        public Criteria andAgentidGreaterThanOrEqualTo(Integer value) {
            addCriterion("agentId >=", value, "agentid");
            return (Criteria) this;
        }

        public Criteria andAgentidLessThan(Integer value) {
            addCriterion("agentId <", value, "agentid");
            return (Criteria) this;
        }

        public Criteria andAgentidLessThanOrEqualTo(Integer value) {
            addCriterion("agentId <=", value, "agentid");
            return (Criteria) this;
        }

        public Criteria andAgentidIn(List<Integer> values) {
            addCriterion("agentId in", values, "agentid");
            return (Criteria) this;
        }

        public Criteria andAgentidNotIn(List<Integer> values) {
            addCriterion("agentId not in", values, "agentid");
            return (Criteria) this;
        }

        public Criteria andAgentidBetween(Integer value1, Integer value2) {
            addCriterion("agentId between", value1, value2, "agentid");
            return (Criteria) this;
        }

        public Criteria andAgentidNotBetween(Integer value1, Integer value2) {
            addCriterion("agentId not between", value1, value2, "agentid");
            return (Criteria) this;
        }

        public Criteria andAgentnameIsNull() {
            addCriterion("agentName is null");
            return (Criteria) this;
        }

        public Criteria andAgentnameIsNotNull() {
            addCriterion("agentName is not null");
            return (Criteria) this;
        }

        public Criteria andAgentnameEqualTo(String value) {
            addCriterion("agentName =", value, "agentname");
            return (Criteria) this;
        }

        public Criteria andAgentnameNotEqualTo(String value) {
            addCriterion("agentName <>", value, "agentname");
            return (Criteria) this;
        }

        public Criteria andAgentnameGreaterThan(String value) {
            addCriterion("agentName >", value, "agentname");
            return (Criteria) this;
        }

        public Criteria andAgentnameGreaterThanOrEqualTo(String value) {
            addCriterion("agentName >=", value, "agentname");
            return (Criteria) this;
        }

        public Criteria andAgentnameLessThan(String value) {
            addCriterion("agentName <", value, "agentname");
            return (Criteria) this;
        }

        public Criteria andAgentnameLessThanOrEqualTo(String value) {
            addCriterion("agentName <=", value, "agentname");
            return (Criteria) this;
        }

        public Criteria andAgentnameLike(String value) {
            addCriterion("agentName like", value, "agentname");
            return (Criteria) this;
        }

        public Criteria andAgentnameNotLike(String value) {
            addCriterion("agentName not like", value, "agentname");
            return (Criteria) this;
        }

        public Criteria andAgentnameIn(List<String> values) {
            addCriterion("agentName in", values, "agentname");
            return (Criteria) this;
        }

        public Criteria andAgentnameNotIn(List<String> values) {
            addCriterion("agentName not in", values, "agentname");
            return (Criteria) this;
        }

        public Criteria andAgentnameBetween(String value1, String value2) {
            addCriterion("agentName between", value1, value2, "agentname");
            return (Criteria) this;
        }

        public Criteria andAgentnameNotBetween(String value1, String value2) {
            addCriterion("agentName not between", value1, value2, "agentname");
            return (Criteria) this;
        }

        public Criteria andStopsIsNull() {
            addCriterion("stops is null");
            return (Criteria) this;
        }

        public Criteria andStopsIsNotNull() {
            addCriterion("stops is not null");
            return (Criteria) this;
        }

        public Criteria andStopsEqualTo(Integer value) {
            addCriterion("stops =", value, "stops");
            return (Criteria) this;
        }

        public Criteria andStopsNotEqualTo(Integer value) {
            addCriterion("stops <>", value, "stops");
            return (Criteria) this;
        }

        public Criteria andStopsGreaterThan(Integer value) {
            addCriterion("stops >", value, "stops");
            return (Criteria) this;
        }

        public Criteria andStopsGreaterThanOrEqualTo(Integer value) {
            addCriterion("stops >=", value, "stops");
            return (Criteria) this;
        }

        public Criteria andStopsLessThan(Integer value) {
            addCriterion("stops <", value, "stops");
            return (Criteria) this;
        }

        public Criteria andStopsLessThanOrEqualTo(Integer value) {
            addCriterion("stops <=", value, "stops");
            return (Criteria) this;
        }

        public Criteria andStopsIn(List<Integer> values) {
            addCriterion("stops in", values, "stops");
            return (Criteria) this;
        }

        public Criteria andStopsNotIn(List<Integer> values) {
            addCriterion("stops not in", values, "stops");
            return (Criteria) this;
        }

        public Criteria andStopsBetween(Integer value1, Integer value2) {
            addCriterion("stops between", value1, value2, "stops");
            return (Criteria) this;
        }

        public Criteria andStopsNotBetween(Integer value1, Integer value2) {
            addCriterion("stops not between", value1, value2, "stops");
            return (Criteria) this;
        }

        public Criteria andGoodsIsNull() {
            addCriterion("goods is null");
            return (Criteria) this;
        }

        public Criteria andGoodsIsNotNull() {
            addCriterion("goods is not null");
            return (Criteria) this;
        }

        public Criteria andGoodsEqualTo(String value) {
            addCriterion("goods =", value, "goods");
            return (Criteria) this;
        }

        public Criteria andGoodsNotEqualTo(String value) {
            addCriterion("goods <>", value, "goods");
            return (Criteria) this;
        }

        public Criteria andGoodsGreaterThan(String value) {
            addCriterion("goods >", value, "goods");
            return (Criteria) this;
        }

        public Criteria andGoodsGreaterThanOrEqualTo(String value) {
            addCriterion("goods >=", value, "goods");
            return (Criteria) this;
        }

        public Criteria andGoodsLessThan(String value) {
            addCriterion("goods <", value, "goods");
            return (Criteria) this;
        }

        public Criteria andGoodsLessThanOrEqualTo(String value) {
            addCriterion("goods <=", value, "goods");
            return (Criteria) this;
        }

        public Criteria andGoodsLike(String value) {
            addCriterion("goods like", value, "goods");
            return (Criteria) this;
        }

        public Criteria andGoodsNotLike(String value) {
            addCriterion("goods not like", value, "goods");
            return (Criteria) this;
        }

        public Criteria andGoodsIn(List<String> values) {
            addCriterion("goods in", values, "goods");
            return (Criteria) this;
        }

        public Criteria andGoodsNotIn(List<String> values) {
            addCriterion("goods not in", values, "goods");
            return (Criteria) this;
        }

        public Criteria andGoodsBetween(String value1, String value2) {
            addCriterion("goods between", value1, value2, "goods");
            return (Criteria) this;
        }

        public Criteria andGoodsNotBetween(String value1, String value2) {
            addCriterion("goods not between", value1, value2, "goods");
            return (Criteria) this;
        }

        public Criteria andDispriceIsNull() {
            addCriterion("disprice is null");
            return (Criteria) this;
        }

        public Criteria andDispriceIsNotNull() {
            addCriterion("disprice is not null");
            return (Criteria) this;
        }

        public Criteria andDispriceEqualTo(BigDecimal value) {
            addCriterion("disprice =", value, "disprice");
            return (Criteria) this;
        }

        public Criteria andDispriceNotEqualTo(BigDecimal value) {
            addCriterion("disprice <>", value, "disprice");
            return (Criteria) this;
        }

        public Criteria andDispriceGreaterThan(BigDecimal value) {
            addCriterion("disprice >", value, "disprice");
            return (Criteria) this;
        }

        public Criteria andDispriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("disprice >=", value, "disprice");
            return (Criteria) this;
        }

        public Criteria andDispriceLessThan(BigDecimal value) {
            addCriterion("disprice <", value, "disprice");
            return (Criteria) this;
        }

        public Criteria andDispriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("disprice <=", value, "disprice");
            return (Criteria) this;
        }

        public Criteria andDispriceIn(List<BigDecimal> values) {
            addCriterion("disprice in", values, "disprice");
            return (Criteria) this;
        }

        public Criteria andDispriceNotIn(List<BigDecimal> values) {
            addCriterion("disprice not in", values, "disprice");
            return (Criteria) this;
        }

        public Criteria andDispriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("disprice between", value1, value2, "disprice");
            return (Criteria) this;
        }

        public Criteria andDispriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("disprice not between", value1, value2, "disprice");
            return (Criteria) this;
        }

        public Criteria andStanidsnameIsNull() {
            addCriterion("stanidsname is null");
            return (Criteria) this;
        }

        public Criteria andStanidsnameIsNotNull() {
            addCriterion("stanidsname is not null");
            return (Criteria) this;
        }

        public Criteria andStanidsnameEqualTo(String value) {
            addCriterion("stanidsname =", value, "stanidsname");
            return (Criteria) this;
        }

        public Criteria andStanidsnameNotEqualTo(String value) {
            addCriterion("stanidsname <>", value, "stanidsname");
            return (Criteria) this;
        }

        public Criteria andStanidsnameGreaterThan(String value) {
            addCriterion("stanidsname >", value, "stanidsname");
            return (Criteria) this;
        }

        public Criteria andStanidsnameGreaterThanOrEqualTo(String value) {
            addCriterion("stanidsname >=", value, "stanidsname");
            return (Criteria) this;
        }

        public Criteria andStanidsnameLessThan(String value) {
            addCriterion("stanidsname <", value, "stanidsname");
            return (Criteria) this;
        }

        public Criteria andStanidsnameLessThanOrEqualTo(String value) {
            addCriterion("stanidsname <=", value, "stanidsname");
            return (Criteria) this;
        }

        public Criteria andStanidsnameLike(String value) {
            addCriterion("stanidsname like", value, "stanidsname");
            return (Criteria) this;
        }

        public Criteria andStanidsnameNotLike(String value) {
            addCriterion("stanidsname not like", value, "stanidsname");
            return (Criteria) this;
        }

        public Criteria andStanidsnameIn(List<String> values) {
            addCriterion("stanidsname in", values, "stanidsname");
            return (Criteria) this;
        }

        public Criteria andStanidsnameNotIn(List<String> values) {
            addCriterion("stanidsname not in", values, "stanidsname");
            return (Criteria) this;
        }

        public Criteria andStanidsnameBetween(String value1, String value2) {
            addCriterion("stanidsname between", value1, value2, "stanidsname");
            return (Criteria) this;
        }

        public Criteria andStanidsnameNotBetween(String value1, String value2) {
            addCriterion("stanidsname not between", value1, value2, "stanidsname");
            return (Criteria) this;
        }

        public Criteria andDeletedIsNull() {
            addCriterion("deleted is null");
            return (Criteria) this;
        }

        public Criteria andDeletedIsNotNull() {
            addCriterion("deleted is not null");
            return (Criteria) this;
        }

        public Criteria andDeletedEqualTo(Integer value) {
            addCriterion("deleted =", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotEqualTo(Integer value) {
            addCriterion("deleted <>", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThan(Integer value) {
            addCriterion("deleted >", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThanOrEqualTo(Integer value) {
            addCriterion("deleted >=", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedLessThan(Integer value) {
            addCriterion("deleted <", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedLessThanOrEqualTo(Integer value) {
            addCriterion("deleted <=", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedIn(List<Integer> values) {
            addCriterion("deleted in", values, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotIn(List<Integer> values) {
            addCriterion("deleted not in", values, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedBetween(Integer value1, Integer value2) {
            addCriterion("deleted between", value1, value2, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotBetween(Integer value1, Integer value2) {
            addCriterion("deleted not between", value1, value2, "deleted");
            return (Criteria) this;
        }

        public Criteria andSharedIsNull() {
            addCriterion("shared is null");
            return (Criteria) this;
        }

        public Criteria andSharedIsNotNull() {
            addCriterion("shared is not null");
            return (Criteria) this;
        }

        public Criteria andSharedEqualTo(Boolean value) {
            addCriterion("shared =", value, "shared");
            return (Criteria) this;
        }

        public Criteria andSharedNotEqualTo(Boolean value) {
            addCriterion("shared <>", value, "shared");
            return (Criteria) this;
        }

        public Criteria andSharedGreaterThan(Boolean value) {
            addCriterion("shared >", value, "shared");
            return (Criteria) this;
        }

        public Criteria andSharedGreaterThanOrEqualTo(Boolean value) {
            addCriterion("shared >=", value, "shared");
            return (Criteria) this;
        }

        public Criteria andSharedLessThan(Boolean value) {
            addCriterion("shared <", value, "shared");
            return (Criteria) this;
        }

        public Criteria andSharedLessThanOrEqualTo(Boolean value) {
            addCriterion("shared <=", value, "shared");
            return (Criteria) this;
        }

        public Criteria andSharedIn(List<Boolean> values) {
            addCriterion("shared in", values, "shared");
            return (Criteria) this;
        }

        public Criteria andSharedNotIn(List<Boolean> values) {
            addCriterion("shared not in", values, "shared");
            return (Criteria) this;
        }

        public Criteria andSharedBetween(Boolean value1, Boolean value2) {
            addCriterion("shared between", value1, value2, "shared");
            return (Criteria) this;
        }

        public Criteria andSharedNotBetween(Boolean value1, Boolean value2) {
            addCriterion("shared not between", value1, value2, "shared");
            return (Criteria) this;
        }

        public Criteria andWeekIsNull() {
            addCriterion("week is null");
            return (Criteria) this;
        }

        public Criteria andWeekIsNotNull() {
            addCriterion("week is not null");
            return (Criteria) this;
        }

        public Criteria andWeekEqualTo(Integer value) {
            addCriterion("week =", value, "week");
            return (Criteria) this;
        }

        public Criteria andWeekNotEqualTo(Integer value) {
            addCriterion("week <>", value, "week");
            return (Criteria) this;
        }

        public Criteria andWeekGreaterThan(Integer value) {
            addCriterion("week >", value, "week");
            return (Criteria) this;
        }

        public Criteria andWeekGreaterThanOrEqualTo(Integer value) {
            addCriterion("week >=", value, "week");
            return (Criteria) this;
        }

        public Criteria andWeekLessThan(Integer value) {
            addCriterion("week <", value, "week");
            return (Criteria) this;
        }

        public Criteria andWeekLessThanOrEqualTo(Integer value) {
            addCriterion("week <=", value, "week");
            return (Criteria) this;
        }

        public Criteria andWeekIn(List<Integer> values) {
            addCriterion("week in", values, "week");
            return (Criteria) this;
        }

        public Criteria andWeekNotIn(List<Integer> values) {
            addCriterion("week not in", values, "week");
            return (Criteria) this;
        }

        public Criteria andWeekBetween(Integer value1, Integer value2) {
            addCriterion("week between", value1, value2, "week");
            return (Criteria) this;
        }

        public Criteria andWeekNotBetween(Integer value1, Integer value2) {
            addCriterion("week not between", value1, value2, "week");
            return (Criteria) this;
        }

        public Criteria andIsLimitedIsNull() {
            addCriterion("is_limited is null");
            return (Criteria) this;
        }

        public Criteria andIsLimitedIsNotNull() {
            addCriterion("is_limited is not null");
            return (Criteria) this;
        }

        public Criteria andIsLimitedEqualTo(Boolean value) {
            addCriterion("is_limited =", value, "isLimited");
            return (Criteria) this;
        }

        public Criteria andIsLimitedNotEqualTo(Boolean value) {
            addCriterion("is_limited <>", value, "isLimited");
            return (Criteria) this;
        }

        public Criteria andIsLimitedGreaterThan(Boolean value) {
            addCriterion("is_limited >", value, "isLimited");
            return (Criteria) this;
        }

        public Criteria andIsLimitedGreaterThanOrEqualTo(Boolean value) {
            addCriterion("is_limited >=", value, "isLimited");
            return (Criteria) this;
        }

        public Criteria andIsLimitedLessThan(Boolean value) {
            addCriterion("is_limited <", value, "isLimited");
            return (Criteria) this;
        }

        public Criteria andIsLimitedLessThanOrEqualTo(Boolean value) {
            addCriterion("is_limited <=", value, "isLimited");
            return (Criteria) this;
        }

        public Criteria andIsLimitedIn(List<Boolean> values) {
            addCriterion("is_limited in", values, "isLimited");
            return (Criteria) this;
        }

        public Criteria andIsLimitedNotIn(List<Boolean> values) {
            addCriterion("is_limited not in", values, "isLimited");
            return (Criteria) this;
        }

        public Criteria andIsLimitedBetween(Boolean value1, Boolean value2) {
            addCriterion("is_limited between", value1, value2, "isLimited");
            return (Criteria) this;
        }

        public Criteria andIsLimitedNotBetween(Boolean value1, Boolean value2) {
            addCriterion("is_limited not between", value1, value2, "isLimited");
            return (Criteria) this;
        }

        public Criteria andLimitTypeIsNull() {
            addCriterion("limit_type is null");
            return (Criteria) this;
        }

        public Criteria andLimitTypeIsNotNull() {
            addCriterion("limit_type is not null");
            return (Criteria) this;
        }

        public Criteria andLimitTypeEqualTo(Integer value) {
            addCriterion("limit_type =", value, "limitType");
            return (Criteria) this;
        }

        public Criteria andLimitTypeNotEqualTo(Integer value) {
            addCriterion("limit_type <>", value, "limitType");
            return (Criteria) this;
        }

        public Criteria andLimitTypeGreaterThan(Integer value) {
            addCriterion("limit_type >", value, "limitType");
            return (Criteria) this;
        }

        public Criteria andLimitTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("limit_type >=", value, "limitType");
            return (Criteria) this;
        }

        public Criteria andLimitTypeLessThan(Integer value) {
            addCriterion("limit_type <", value, "limitType");
            return (Criteria) this;
        }

        public Criteria andLimitTypeLessThanOrEqualTo(Integer value) {
            addCriterion("limit_type <=", value, "limitType");
            return (Criteria) this;
        }

        public Criteria andLimitTypeIn(List<Integer> values) {
            addCriterion("limit_type in", values, "limitType");
            return (Criteria) this;
        }

        public Criteria andLimitTypeNotIn(List<Integer> values) {
            addCriterion("limit_type not in", values, "limitType");
            return (Criteria) this;
        }

        public Criteria andLimitTypeBetween(Integer value1, Integer value2) {
            addCriterion("limit_type between", value1, value2, "limitType");
            return (Criteria) this;
        }

        public Criteria andLimitTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("limit_type not between", value1, value2, "limitType");
            return (Criteria) this;
        }

        public Criteria andLimitNumIsNull() {
            addCriterion("limit_num is null");
            return (Criteria) this;
        }

        public Criteria andLimitNumIsNotNull() {
            addCriterion("limit_num is not null");
            return (Criteria) this;
        }

        public Criteria andLimitNumEqualTo(Integer value) {
            addCriterion("limit_num =", value, "limitNum");
            return (Criteria) this;
        }

        public Criteria andLimitNumNotEqualTo(Integer value) {
            addCriterion("limit_num <>", value, "limitNum");
            return (Criteria) this;
        }

        public Criteria andLimitNumGreaterThan(Integer value) {
            addCriterion("limit_num >", value, "limitNum");
            return (Criteria) this;
        }

        public Criteria andLimitNumGreaterThanOrEqualTo(Integer value) {
            addCriterion("limit_num >=", value, "limitNum");
            return (Criteria) this;
        }

        public Criteria andLimitNumLessThan(Integer value) {
            addCriterion("limit_num <", value, "limitNum");
            return (Criteria) this;
        }

        public Criteria andLimitNumLessThanOrEqualTo(Integer value) {
            addCriterion("limit_num <=", value, "limitNum");
            return (Criteria) this;
        }

        public Criteria andLimitNumIn(List<Integer> values) {
            addCriterion("limit_num in", values, "limitNum");
            return (Criteria) this;
        }

        public Criteria andLimitNumNotIn(List<Integer> values) {
            addCriterion("limit_num not in", values, "limitNum");
            return (Criteria) this;
        }

        public Criteria andLimitNumBetween(Integer value1, Integer value2) {
            addCriterion("limit_num between", value1, value2, "limitNum");
            return (Criteria) this;
        }

        public Criteria andLimitNumNotBetween(Integer value1, Integer value2) {
            addCriterion("limit_num not between", value1, value2, "limitNum");
            return (Criteria) this;
        }

        public Criteria andTimeSpanIsNull() {
            addCriterion("time_span is null");
            return (Criteria) this;
        }

        public Criteria andTimeSpanIsNotNull() {
            addCriterion("time_span is not null");
            return (Criteria) this;
        }

        public Criteria andTimeSpanEqualTo(String value) {
            addCriterion("time_span =", value, "timeSpan");
            return (Criteria) this;
        }

        public Criteria andTimeSpanNotEqualTo(String value) {
            addCriterion("time_span <>", value, "timeSpan");
            return (Criteria) this;
        }

        public Criteria andTimeSpanGreaterThan(String value) {
            addCriterion("time_span >", value, "timeSpan");
            return (Criteria) this;
        }

        public Criteria andTimeSpanGreaterThanOrEqualTo(String value) {
            addCriterion("time_span >=", value, "timeSpan");
            return (Criteria) this;
        }

        public Criteria andTimeSpanLessThan(String value) {
            addCriterion("time_span <", value, "timeSpan");
            return (Criteria) this;
        }

        public Criteria andTimeSpanLessThanOrEqualTo(String value) {
            addCriterion("time_span <=", value, "timeSpan");
            return (Criteria) this;
        }

        public Criteria andTimeSpanLike(String value) {
            addCriterion("time_span like", value, "timeSpan");
            return (Criteria) this;
        }

        public Criteria andTimeSpanNotLike(String value) {
            addCriterion("time_span not like", value, "timeSpan");
            return (Criteria) this;
        }

        public Criteria andTimeSpanIn(List<String> values) {
            addCriterion("time_span in", values, "timeSpan");
            return (Criteria) this;
        }

        public Criteria andTimeSpanNotIn(List<String> values) {
            addCriterion("time_span not in", values, "timeSpan");
            return (Criteria) this;
        }

        public Criteria andTimeSpanBetween(String value1, String value2) {
            addCriterion("time_span between", value1, value2, "timeSpan");
            return (Criteria) this;
        }

        public Criteria andTimeSpanNotBetween(String value1, String value2) {
            addCriterion("time_span not between", value1, value2, "timeSpan");
            return (Criteria) this;
        }

        public Criteria andAgentSubsidyIsNull() {
            addCriterion("agent_subsidy is null");
            return (Criteria) this;
        }

        public Criteria andAgentSubsidyIsNotNull() {
            addCriterion("agent_subsidy is not null");
            return (Criteria) this;
        }

        public Criteria andAgentSubsidyEqualTo(Double value) {
            addCriterion("agent_subsidy =", value, "agentSubsidy");
            return (Criteria) this;
        }

        public Criteria andAgentSubsidyNotEqualTo(Double value) {
            addCriterion("agent_subsidy <>", value, "agentSubsidy");
            return (Criteria) this;
        }

        public Criteria andAgentSubsidyGreaterThan(Double value) {
            addCriterion("agent_subsidy >", value, "agentSubsidy");
            return (Criteria) this;
        }

        public Criteria andAgentSubsidyGreaterThanOrEqualTo(Double value) {
            addCriterion("agent_subsidy >=", value, "agentSubsidy");
            return (Criteria) this;
        }

        public Criteria andAgentSubsidyLessThan(Double value) {
            addCriterion("agent_subsidy <", value, "agentSubsidy");
            return (Criteria) this;
        }

        public Criteria andAgentSubsidyLessThanOrEqualTo(Double value) {
            addCriterion("agent_subsidy <=", value, "agentSubsidy");
            return (Criteria) this;
        }

        public Criteria andAgentSubsidyIn(List<Double> values) {
            addCriterion("agent_subsidy in", values, "agentSubsidy");
            return (Criteria) this;
        }

        public Criteria andAgentSubsidyNotIn(List<Double> values) {
            addCriterion("agent_subsidy not in", values, "agentSubsidy");
            return (Criteria) this;
        }

        public Criteria andAgentSubsidyBetween(Double value1, Double value2) {
            addCriterion("agent_subsidy between", value1, value2, "agentSubsidy");
            return (Criteria) this;
        }

        public Criteria andAgentSubsidyNotBetween(Double value1, Double value2) {
            addCriterion("agent_subsidy not between", value1, value2, "agentSubsidy");
            return (Criteria) this;
        }

        public Criteria andSpecialTypeIsNull() {
            addCriterion("special_type is null");
            return (Criteria) this;
        }

        public Criteria andSpecialTypeIsNotNull() {
            addCriterion("special_type is not null");
            return (Criteria) this;
        }

        public Criteria andSpecialTypeEqualTo(Integer value) {
            addCriterion("special_type =", value, "specialType");
            return (Criteria) this;
        }

        public Criteria andSpecialTypeNotEqualTo(Integer value) {
            addCriterion("special_type <>", value, "specialType");
            return (Criteria) this;
        }

        public Criteria andSpecialTypeGreaterThan(Integer value) {
            addCriterion("special_type >", value, "specialType");
            return (Criteria) this;
        }

        public Criteria andSpecialTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("special_type >=", value, "specialType");
            return (Criteria) this;
        }

        public Criteria andSpecialTypeLessThan(Integer value) {
            addCriterion("special_type <", value, "specialType");
            return (Criteria) this;
        }

        public Criteria andSpecialTypeLessThanOrEqualTo(Integer value) {
            addCriterion("special_type <=", value, "specialType");
            return (Criteria) this;
        }

        public Criteria andSpecialTypeIn(List<Integer> values) {
            addCriterion("special_type in", values, "specialType");
            return (Criteria) this;
        }

        public Criteria andSpecialTypeNotIn(List<Integer> values) {
            addCriterion("special_type not in", values, "specialType");
            return (Criteria) this;
        }

        public Criteria andSpecialTypeBetween(Integer value1, Integer value2) {
            addCriterion("special_type between", value1, value2, "specialType");
            return (Criteria) this;
        }

        public Criteria andSpecialTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("special_type not between", value1, value2, "specialType");
            return (Criteria) this;
        }

        public Criteria andSpecialNameIsNull() {
            addCriterion("special_name is null");
            return (Criteria) this;
        }

        public Criteria andSpecialNameIsNotNull() {
            addCriterion("special_name is not null");
            return (Criteria) this;
        }

        public Criteria andSpecialNameEqualTo(String value) {
            addCriterion("special_name =", value, "specialName");
            return (Criteria) this;
        }

        public Criteria andSpecialNameNotEqualTo(String value) {
            addCriterion("special_name <>", value, "specialName");
            return (Criteria) this;
        }

        public Criteria andSpecialNameGreaterThan(String value) {
            addCriterion("special_name >", value, "specialName");
            return (Criteria) this;
        }

        public Criteria andSpecialNameGreaterThanOrEqualTo(String value) {
            addCriterion("special_name >=", value, "specialName");
            return (Criteria) this;
        }

        public Criteria andSpecialNameLessThan(String value) {
            addCriterion("special_name <", value, "specialName");
            return (Criteria) this;
        }

        public Criteria andSpecialNameLessThanOrEqualTo(String value) {
            addCriterion("special_name <=", value, "specialName");
            return (Criteria) this;
        }

        public Criteria andSpecialNameLike(String value) {
            addCriterion("special_name like", value, "specialName");
            return (Criteria) this;
        }

        public Criteria andSpecialNameNotLike(String value) {
            addCriterion("special_name not like", value, "specialName");
            return (Criteria) this;
        }

        public Criteria andSpecialNameIn(List<String> values) {
            addCriterion("special_name in", values, "specialName");
            return (Criteria) this;
        }

        public Criteria andSpecialNameNotIn(List<String> values) {
            addCriterion("special_name not in", values, "specialName");
            return (Criteria) this;
        }

        public Criteria andSpecialNameBetween(String value1, String value2) {
            addCriterion("special_name between", value1, value2, "specialName");
            return (Criteria) this;
        }

        public Criteria andSpecialNameNotBetween(String value1, String value2) {
            addCriterion("special_name not between", value1, value2, "specialName");
            return (Criteria) this;
        }

        public Criteria andRedValidDayIsNull() {
            addCriterion("red_valid_day is null");
            return (Criteria) this;
        }

        public Criteria andRedValidDayIsNotNull() {
            addCriterion("red_valid_day is not null");
            return (Criteria) this;
        }

        public Criteria andRedValidDayEqualTo(Integer value) {
            addCriterion("red_valid_day =", value, "redValidDay");
            return (Criteria) this;
        }

        public Criteria andRedValidDayNotEqualTo(Integer value) {
            addCriterion("red_valid_day <>", value, "redValidDay");
            return (Criteria) this;
        }

        public Criteria andRedValidDayGreaterThan(Integer value) {
            addCriterion("red_valid_day >", value, "redValidDay");
            return (Criteria) this;
        }

        public Criteria andRedValidDayGreaterThanOrEqualTo(Integer value) {
            addCriterion("red_valid_day >=", value, "redValidDay");
            return (Criteria) this;
        }

        public Criteria andRedValidDayLessThan(Integer value) {
            addCriterion("red_valid_day <", value, "redValidDay");
            return (Criteria) this;
        }

        public Criteria andRedValidDayLessThanOrEqualTo(Integer value) {
            addCriterion("red_valid_day <=", value, "redValidDay");
            return (Criteria) this;
        }

        public Criteria andRedValidDayIn(List<Integer> values) {
            addCriterion("red_valid_day in", values, "redValidDay");
            return (Criteria) this;
        }

        public Criteria andRedValidDayNotIn(List<Integer> values) {
            addCriterion("red_valid_day not in", values, "redValidDay");
            return (Criteria) this;
        }

        public Criteria andRedValidDayBetween(Integer value1, Integer value2) {
            addCriterion("red_valid_day between", value1, value2, "redValidDay");
            return (Criteria) this;
        }

        public Criteria andRedValidDayNotBetween(Integer value1, Integer value2) {
            addCriterion("red_valid_day not between", value1, value2, "redValidDay");
            return (Criteria) this;
        }

        public Criteria andRedTotalNumIsNull() {
            addCriterion("red_total_num is null");
            return (Criteria) this;
        }

        public Criteria andRedTotalNumIsNotNull() {
            addCriterion("red_total_num is not null");
            return (Criteria) this;
        }

        public Criteria andRedTotalNumEqualTo(Integer value) {
            addCriterion("red_total_num =", value, "redTotalNum");
            return (Criteria) this;
        }

        public Criteria andRedTotalNumNotEqualTo(Integer value) {
            addCriterion("red_total_num <>", value, "redTotalNum");
            return (Criteria) this;
        }

        public Criteria andRedTotalNumGreaterThan(Integer value) {
            addCriterion("red_total_num >", value, "redTotalNum");
            return (Criteria) this;
        }

        public Criteria andRedTotalNumGreaterThanOrEqualTo(Integer value) {
            addCriterion("red_total_num >=", value, "redTotalNum");
            return (Criteria) this;
        }

        public Criteria andRedTotalNumLessThan(Integer value) {
            addCriterion("red_total_num <", value, "redTotalNum");
            return (Criteria) this;
        }

        public Criteria andRedTotalNumLessThanOrEqualTo(Integer value) {
            addCriterion("red_total_num <=", value, "redTotalNum");
            return (Criteria) this;
        }

        public Criteria andRedTotalNumIn(List<Integer> values) {
            addCriterion("red_total_num in", values, "redTotalNum");
            return (Criteria) this;
        }

        public Criteria andRedTotalNumNotIn(List<Integer> values) {
            addCriterion("red_total_num not in", values, "redTotalNum");
            return (Criteria) this;
        }

        public Criteria andRedTotalNumBetween(Integer value1, Integer value2) {
            addCriterion("red_total_num between", value1, value2, "redTotalNum");
            return (Criteria) this;
        }

        public Criteria andRedTotalNumNotBetween(Integer value1, Integer value2) {
            addCriterion("red_total_num not between", value1, value2, "redTotalNum");
            return (Criteria) this;
        }

        public Criteria andRedPersonNumIsNull() {
            addCriterion("red_person_num is null");
            return (Criteria) this;
        }

        public Criteria andRedPersonNumIsNotNull() {
            addCriterion("red_person_num is not null");
            return (Criteria) this;
        }

        public Criteria andRedPersonNumEqualTo(Integer value) {
            addCriterion("red_person_num =", value, "redPersonNum");
            return (Criteria) this;
        }

        public Criteria andRedPersonNumNotEqualTo(Integer value) {
            addCriterion("red_person_num <>", value, "redPersonNum");
            return (Criteria) this;
        }

        public Criteria andRedPersonNumGreaterThan(Integer value) {
            addCriterion("red_person_num >", value, "redPersonNum");
            return (Criteria) this;
        }

        public Criteria andRedPersonNumGreaterThanOrEqualTo(Integer value) {
            addCriterion("red_person_num >=", value, "redPersonNum");
            return (Criteria) this;
        }

        public Criteria andRedPersonNumLessThan(Integer value) {
            addCriterion("red_person_num <", value, "redPersonNum");
            return (Criteria) this;
        }

        public Criteria andRedPersonNumLessThanOrEqualTo(Integer value) {
            addCriterion("red_person_num <=", value, "redPersonNum");
            return (Criteria) this;
        }

        public Criteria andRedPersonNumIn(List<Integer> values) {
            addCriterion("red_person_num in", values, "redPersonNum");
            return (Criteria) this;
        }

        public Criteria andRedPersonNumNotIn(List<Integer> values) {
            addCriterion("red_person_num not in", values, "redPersonNum");
            return (Criteria) this;
        }

        public Criteria andRedPersonNumBetween(Integer value1, Integer value2) {
            addCriterion("red_person_num between", value1, value2, "redPersonNum");
            return (Criteria) this;
        }

        public Criteria andRedPersonNumNotBetween(Integer value1, Integer value2) {
            addCriterion("red_person_num not between", value1, value2, "redPersonNum");
            return (Criteria) this;
        }

        public Criteria andRedAmountIsNull() {
            addCriterion("red_amount is null");
            return (Criteria) this;
        }

        public Criteria andRedAmountIsNotNull() {
            addCriterion("red_amount is not null");
            return (Criteria) this;
        }

        public Criteria andRedAmountEqualTo(String value) {
            addCriterion("red_amount =", value, "redAmount");
            return (Criteria) this;
        }

        public Criteria andRedAmountNotEqualTo(String value) {
            addCriterion("red_amount <>", value, "redAmount");
            return (Criteria) this;
        }

        public Criteria andRedAmountGreaterThan(String value) {
            addCriterion("red_amount >", value, "redAmount");
            return (Criteria) this;
        }

        public Criteria andRedAmountGreaterThanOrEqualTo(String value) {
            addCriterion("red_amount >=", value, "redAmount");
            return (Criteria) this;
        }

        public Criteria andRedAmountLessThan(String value) {
            addCriterion("red_amount <", value, "redAmount");
            return (Criteria) this;
        }

        public Criteria andRedAmountLessThanOrEqualTo(String value) {
            addCriterion("red_amount <=", value, "redAmount");
            return (Criteria) this;
        }

        public Criteria andRedAmountLike(String value) {
            addCriterion("red_amount like", value, "redAmount");
            return (Criteria) this;
        }

        public Criteria andRedAmountNotLike(String value) {
            addCriterion("red_amount not like", value, "redAmount");
            return (Criteria) this;
        }

        public Criteria andRedAmountIn(List<String> values) {
            addCriterion("red_amount in", values, "redAmount");
            return (Criteria) this;
        }

        public Criteria andRedAmountNotIn(List<String> values) {
            addCriterion("red_amount not in", values, "redAmount");
            return (Criteria) this;
        }

        public Criteria andRedAmountBetween(String value1, String value2) {
            addCriterion("red_amount between", value1, value2, "redAmount");
            return (Criteria) this;
        }

        public Criteria andRedAmountNotBetween(String value1, String value2) {
            addCriterion("red_amount not between", value1, value2, "redAmount");
            return (Criteria) this;
        }

        public Criteria andRedTotalPickNumIsNull() {
            addCriterion("red_total_pick_num is null");
            return (Criteria) this;
        }

        public Criteria andRedTotalPickNumIsNotNull() {
            addCriterion("red_total_pick_num is not null");
            return (Criteria) this;
        }

        public Criteria andRedTotalPickNumEqualTo(Integer value) {
            addCriterion("red_total_pick_num =", value, "redTotalPickNum");
            return (Criteria) this;
        }

        public Criteria andRedTotalPickNumNotEqualTo(Integer value) {
            addCriterion("red_total_pick_num <>", value, "redTotalPickNum");
            return (Criteria) this;
        }

        public Criteria andRedTotalPickNumGreaterThan(Integer value) {
            addCriterion("red_total_pick_num >", value, "redTotalPickNum");
            return (Criteria) this;
        }

        public Criteria andRedTotalPickNumGreaterThanOrEqualTo(Integer value) {
            addCriterion("red_total_pick_num >=", value, "redTotalPickNum");
            return (Criteria) this;
        }

        public Criteria andRedTotalPickNumLessThan(Integer value) {
            addCriterion("red_total_pick_num <", value, "redTotalPickNum");
            return (Criteria) this;
        }

        public Criteria andRedTotalPickNumLessThanOrEqualTo(Integer value) {
            addCriterion("red_total_pick_num <=", value, "redTotalPickNum");
            return (Criteria) this;
        }

        public Criteria andRedTotalPickNumIn(List<Integer> values) {
            addCriterion("red_total_pick_num in", values, "redTotalPickNum");
            return (Criteria) this;
        }

        public Criteria andRedTotalPickNumNotIn(List<Integer> values) {
            addCriterion("red_total_pick_num not in", values, "redTotalPickNum");
            return (Criteria) this;
        }

        public Criteria andRedTotalPickNumBetween(Integer value1, Integer value2) {
            addCriterion("red_total_pick_num between", value1, value2, "redTotalPickNum");
            return (Criteria) this;
        }

        public Criteria andRedTotalPickNumNotBetween(Integer value1, Integer value2) {
            addCriterion("red_total_pick_num not between", value1, value2, "redTotalPickNum");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}